﻿CREATE TABLE [dbo].[Worklog] (
    [ID]             INT          IDENTITY (1, 1) NOT NULL,
	[JiraWorklogID] nvarchar(50) NOT NULL,
    [IssueID]        INT          NOT NULL,
    [AuthorID]       INT          NOT NULL,
    [Body]           NVARCHAR (MAX) NULL,
    [Created]        DATETIME     NULL,
    [UpdateAuthorID] INT          NOT NULL,
    [Updated]        DATETIME     NULL,
    [StartDate]      DATETIME     NULL,
    [TimeWorked]     NUMERIC (18) NOT NULL
);

